﻿using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Configuration;
using DAL;
using Common;


public partial class System_User : System.Web.UI.Page
{
    protected string MenuType
    {
        get { return string.IsNullOrEmpty(Request["menutype"]) ? "" : Request["menutype"].ToString(); }
    }

    protected void Page_PreRender(object sender, EventArgs e)
    {
        //条件 Hashtable

        Hashtable tb = new Hashtable();
        bool QueryAdd = false;

        if (!string.IsNullOrEmpty(RealName.Text.Trim()))
        {
            tb.Add("RealName", RealName.Text.Trim());
            QueryAdd = true;
        }
        if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
        {
            tb.Add("Keyword", Keyword.Text.Trim());
            QueryAdd = true;
        }
        tb = QueryAdd ? tb : null;

        UserDataBind(tb);
    }

    private void UserDataBind(Hashtable QueryTable)
    {
        lv_User.DataSource = new Account().SelectAccount(QueryTable);
        lv_User.DataBind();

        if (DataPager1.TotalRowCount == 0)
            DataPager1.Visible = false;
    }

    //搜索
    protected void submit_Click(object sender, EventArgs e)
    {
        //条件 Hashtable

        Hashtable tb = new Hashtable();
        bool QueryAdd = false;

        if (!string.IsNullOrEmpty(RealName.Text.Trim()))
        {
            tb.Add("RealName", RealName.Text.Trim());
            QueryAdd = true;
        }
        if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
        {
            tb.Add("Keyword", Keyword.Text.Trim());
            QueryAdd = true;
        }
        tb = QueryAdd ? tb : null;

        UserDataBind(tb);
    }



    //DropDownList分页选择
    protected void PageList_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList pagelist = (DropDownList)sender;

        int CurPage = Convert.ToInt32(pagelist.SelectedValue);
        int TotalPage = WebUtility.GetTotalPage(DataPager1.TotalRowCount, DataPager1.PageSize);

        DataPager1.SetPageProperties((CurPage - 1) * DataPager1.PageSize, DataPager1.PageSize, true);
    }

    protected void lv_User_DataBound(object sender, EventArgs e)
    {
        DropDownList pagelist = (DropDownList)DataPager1.Controls[4].FindControl("PageList");

        int CurPage = WebUtility.GetCurrentPage(DataPager1.StartRowIndex, DataPager1.PageSize);
        int TotalPage = WebUtility.GetTotalPage(DataPager1.TotalRowCount, DataPager1.PageSize);
        for (int i = 1; i <= TotalPage; i++)
            pagelist.Items.Add(new ListItem("第" + i.ToString() + "页", i.ToString()));
        pagelist.SelectedValue = CurPage.ToString();
    }


    //Delete
    protected void lv_User_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {
        int UserKey = Convert.ToInt32(lv_User.DataKeys[e.ItemIndex].Value);
        new Account().DelAccount(UserKey);
    }

    //Export
    protected void submit0_Click(object sender, EventArgs e)
    {
        
        //条件 Hashtable

        Hashtable tb = new Hashtable();
        bool QueryAdd = false;

        if (!string.IsNullOrEmpty(RealName.Text.Trim()))
        {
            tb.Add("RealName", RealName.Text.Trim());
            QueryAdd = true;
        }
        if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
        {
            tb.Add("Keyword", Keyword.Text.Trim());
            QueryAdd = true;
        }
        tb = QueryAdd ? tb : null;

        //Account.DataToExcel_(tb);

        Account.DataToExcel(tb);
    }
}
